If Tourplan NX accounting has been used for a time prior to the Bank Reconciliation being used, then a Bank Reconciliation starting date needs to be determined and any existing transactions dated prior to the reconciliation start date need to be tagged to prevent them from appearing in the reconciliation in the future.

In other words remove by tagging all those transactions that will not appear on a future bank statement page.

Bank Reconciliation Initialisation

1. From the Home menu, select Financials > Accounting > Bank Reconciliation.

   1. Click the Home Menu to expand it:

      

   2. Click the Financials menu option to expand it:

      

   3. Click Accounting to go to the Accounting menu to expand it:

      

   4. Click Bank Reconciliation to go to the Bank Reconciliation screen:

      

2. When the Bank Reconciliation Setup is completed and saved, the Statement Details Screen displays with no reconciled pages listed. Click Exit.

   

3. The Bank Account screen will display with the Reconciled Pages tab open. Either click Insert or the Page Line.

   

4. Select the Reconciliation Date, tag check box(es) for the required transaction lines to be included in the initialisation, and click Audit.

   

5. Click Save to keep the changes.

   

6. Click Exit to discard any changes.

   

1. When the Bank Reconciliation Setup is completed and saved, the Statement Details screen displays with no reconciled pages listed. Click the Grey Exit Button.

   

   Any edits to the date etc. can be made in the next screen.
2. On Exit, the Reconciled Pages tab is highlighted and the Initialisation Page Number and Starting Page Balance values have defaulted to it. The Opening Page Balance can not be changed.

   

3. Click either the Grey Insert button or the Page line.
4. The statement details page will open with the Page Number, Opening and Closing page balances as entered in the details screen defaulted into it. A list of unreconciled transactions displays.

   Example Bank Reconciliation - Initialisation Page

   

 

NOTE: When at least one transaction line has been tagged, an Audit Button becomes active. Clicking the Audit Button will open the currently highlighted transaction to provide full details of it.

The example above is showing old transactions, which is not uncommon when the Bank Reconciliation is started some months or years after the system has been installed and used - generally as a result of a staggered implementation.

Reconciliation Date (Date-Time)

This defaults to todays date, but can be overridden to be the bank statement date.

Reconciliation User (Char 30)

This field defaults to the current logged in user, it can be overridden to another user name if required.

Page Number (Char 10)

The page number automatically increments by 1 from the previous reconciliation page number. This should match the page number of the bank statement being reconciled. The page number can be edited, but only if the accounting period the reconciliation is in is an open period.

Closing Page Balance (Numeric 16,4)

Enter the closing balance from the bank statement being reconciled.

Opening Page Balance (Display Only)

The closing balance from the previously reconciled bank statements